﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Linq.Mapping;

namespace ServiciosProductos
{
    [Table(Name = "Products")]
    public class Product
    {
        //[DisplayName("ID")]
        [Column(IsPrimaryKey = true, IsDbGenerated = true)]
        public long ProductId { get; set; }
        //[DisplayName("Nombre")]
        [Column]
        public string Name { get; set; }
        //[DisplayName("Espectáculo")]
        [Column]
        public string Show { get; set; }
        //[DisplayName("Fecha del Espectáculo")]
        [Column]
        public DateTime ShowDate { get; set; }
        [Column]
        public string CityId { get; set; }
        [Column]
        public DateTime ArrivalDate { get; set; }
        [Column]
        public DateTime DepartureDate { get; set; }
        [Column]
        public long? TransportationRateId { get; set; }
        [Column]
        public long ShowRateId { get; set; }
        [Column]
        public long? AccommodationRateId { get; set; }
        [Column]
        public string Image { get; set; }

        public City City { get; set; }        
        public virtual TransportationRate TransportationRate { get; set; }
        public virtual ShowRate ShowRate { get; set; }
        public virtual AccommodationRate AccommodationRate { get; set; }
    }
}